IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'CGO_GameEnrollment')
                    AND OBJECTPROPERTY(id, N'IsTable') = 1 ) 
  BEGIN
    DROP TABLE dbo.CGO_GameEnrollment
  END
  
CREATE TABLE [dbo].[CGO_GameEnrollment]
(
[EnrollmentID] [int] NOT NULL IDENTITY(1, 1),
[PortalID] [int] NOT NULL,
[EventID] [int] NOT NULL,
[GameID] [int] NOT NULL,
[UserID] [int] NOT NULL,
[EnrollStatusID] [int] NOT NULL,
[EnrollFee] [money] NULL,
[StartTime] [datetime] NULL,
[EndTime] [datetime] NULL,
[ConnectCount] [int] NULL,
[Score] [decimal] NULL,
[CreatedDate] [datetime] NOT NULL,
[LastUpdateDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CGO_GameEnrollment] ADD CONSTRAINT [PK_CGO_GameEnrollment] PRIMARY KEY CLUSTERED  ([EnrollmentID]) ON [PRIMARY]
GO